package com.kim.rssreader.domain.constant;

public class CityWeatherCode {
	public static final String TABLE_NAME = "rss_cityweathercode";

	public static final String KEY = "_id"; // 逻辑主键
	
//	public static final String CITYID = "_cityid";

	public static final String CITY = "_city";

	public static final String CODE = "_code"; // 栏目关注度


	public static final int COLUMN_KEY = 0;
//	public static final int COLUMN_CITYID = 1;
	public static final int COLUMN_CITY = 2;
	public static final int COLUMN_CODE = 3;

	public static final String[] COLUMNS = new String[] { KEY, /*CITYID, */CITY,
		CODE };

	public static final String SQL_CREATE = "CREATE  TABLE IF NOT EXISTS `rss_cityweathercode` ("
			+ "`_id` INTEGER PRIMARY KEY AUTOINCREMENT,"
//			+ "`_cityid` VARCHAR(36) NOT NULL,"
			+ "`_city` VARCHAR(36) NOT NULL,"
			+ "`_code` VARCHAR(36) NOT NULL, unique(`_code`) ON CONFLICT IGNORE ) ";

}
